create procedure [dbo].[BAEUpdateRegistrantEventOrderInfo] @orderNumber float,
     @eventCode as
varchar(10),
    @regID AS varchar(10)
AS
    UPDATE Orders
    SET FIRST_NAME = ev.FirstName, LAST_NAME = ev.LastName, MIDDLE_NAME = ev.MiddleInitial, ADDRESS_1 = ev.Address1,
        ADDRESS_2 = ev.Address2, ADDRESS_3 = ev.Address3, CITY = ev.City, STATE_PROVINCE = ev.StateProvince, ZIP = ev.PostalCode,
        EMAIL = ev.Email, PHONE = ev.Phone
    FROM EventRegistrant ev
    WHERE ORDER_NUMBER = @orderNumber AND ev.RegistrantID = @regID AND ev.EventCode = @eventCode

GO